CREATE TABLE [dbo].[OpportunityMainDonor]
(
[OpportunityKey] [uniqueidentifier] NOT NULL,
[Distribution] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DecisionDate] [datetime] NULL,
[TimingProbability] [decimal] (12, 4) NOT NULL CONSTRAINT [DF_OpportunityMainDonor_TimingProbability] DEFAULT ((0)),
[Potential] [decimal] (18, 4) NOT NULL,
[Actual] [decimal] (18, 4) NOT NULL,
[Quality] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ResponseMedia] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[OpportunityMainDonor] ADD CONSTRAINT [PK_OpportunityMainDonor] PRIMARY KEY CLUSTERED ([OpportunityKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OpportunityMainDonor] ON [dbo].[OpportunityMainDonor] ([OpportunityKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OpportunityMainDonor] ADD CONSTRAINT [FK_OpportunityMainDonor_OpportunityMain] FOREIGN KEY ([OpportunityKey]) REFERENCES [dbo].[OpportunityMain] ([OpportunityKey])
GO